AX_GLSBAT Data Dictionary

Expanded Names and Descriptions for General Ledger Sub-Batch Table

Original Column Name Expanded Column Name Description
GLSBATID General Ledger Sub-Batch ID Unique identifier for a sub-batch within the general ledger.
Amt Amount Total financial value handled in the sub-batch.
Balance Balance Current outstanding balance after transactions in the sub-batch.
CAID Cash Account ID Identifier for the cash account involved in the sub-batch.
CAGrpID Cash Account Group ID Identifier for the group of cash accounts the transaction belongs to.
DeptID Department ID Identifier for the department responsible for the sub-batch.
DescX Description Detailed narrative explaining the purpose or contents of the sub-batch.
DtClr Date Cleared Date when the sub-batch was finalized and cleared.
DtPost Date Posted Date when the sub-batch was officially posted to the general ledger.
DtTrans Date Transaction Date when the actual transactions within the sub-batch occurred.
EmpID Employee ID Identifier for the employee related to the transactions in the sub-batch.
GLID General Ledger ID Identifier for a specific entry within the general ledger.
GLSBATID_Ref General Ledger Sub-Batch ID Reference Referential ID linking the sub-batch to other related records or entries.
IsCleared Is Cleared Indicator specifying whether the sub-batch has been cleared (true/false).
IsPrint Is Printed Indicator showing if the sub-batch records have been physically printed (true/false).
IsVoided Is Voided Indicator of whether the sub-batch has been voided or invalidated (true/false).
ItemPOID Item Purchase Order ID Identifier of the purchase order related to the transaction items.
PayMethodID Payment Method ID Identifier for the payment method used in the transactions.
RecptID Recipient ID Identifier for the recipient of funds or transactions.
RecptTypeID Recipient Type ID Identifier for the type or category of the transaction recipient.
RefNo Reference Number Unique reference number for identifying the sub-batch.
RefText Reference Text Additional text providing context or details related to the reference number.
SiteID Site ID Identifier for the physical or logical site related to the transaction.
TransTypeID Transaction Type ID Identifier defining the type of transaction within the sub-batch.
ZUChkSum ZU Check Sum Checksum value used for data integrity verification in audit logs.
ZUDate ZU Date Date and time when an entry was used or modified for audit purposes.
ZULogonHisID ZU Logon History ID Identifier for a specific user logon event for auditing.